using System.Data;
using ET;
namespace DA
{
	public class Quotes_Provision_DAL
	{
	private clsConnect cls = new clsConnect();

	#region Getdata
	public DataTable BindGirdtb_Quotes_Provision(int id)
	{
        return cls.GetData_ID_Int("sp_tb_Quotes_Provision_Search", "@QuotesID", id);
	}
    //public DataTable BindGirdtb_Quotes_ProvisionDetail(int id)
    //{
    //}
	#endregion

	#region Insert
	public bool Inserttb_Quotes_Provision(Quotes_Provision_ET data)
	{
	cls.CreateNewSqlCommand();
	cls.AddParameter("@Quotes_Provision_Name", data.Quotes_Provision_Name);
	cls.AddParameter("@Quotes_Provision_Value", data.Quotes_Provision_Value);
	cls.AddParameter("@Quotes_ID", data.Quotes_ID);
	cls.ExecuteNonQuery("sp_tb_Quotes_Provision_Insert");
	return true;
	}
	#endregion

	#region Update
	public bool Updatetb_Quotes_Provision(Quotes_Provision_ET data)
	{
	cls.CreateNewSqlCommand();
	cls.AddParameter("@Quotes_Provision_ID", data.Quotes_Provision_ID);
	cls.AddParameter("@Quotes_Provision_Name", data.Quotes_Provision_Name);
	cls.AddParameter("@Quotes_Provision_Value", data.Quotes_Provision_Value);
	cls.AddParameter("@Quotes_ID", data.Quotes_ID);
	cls.ExecuteNonQuery("sp_tb_Quotes_Provision_Update");
	return true;
	}
	#endregion

	#region Delete
	public bool Deletetb_Quotes_Provision(int id)
	{
        cls.Delete("sp_tb_Quotes_Provision_Delete", "@Quotes_Provision_ID", id);
	return true;
	}
	#endregion
	}
}